import pymysql

db = pymysql.connect(host='localhost', user='root', password='123456', port=3306, database='test')
cursor = db.cursor()
sql = "SELECT*FROM EMPLOYEE WHERE INCOME >%d" % (1000)
try:
    cursor.execute(sql)
    results = cursor.fetchall()
    for row in results:
        fname = row[1]
        lname = row[2]
        age = row[3]
        sex = row[4]
        income = row[5]
        print("name= % s % s ,age= % s ,sex= % s,income = %s" % (fname, lname, age, sex, income))

except:
    import traceback

    traceback.print_exc()
    print("Error:unable to fetch data")

db.close()
